package com.kakame.codenews.front.menu.dao;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.kakame.codenews.base.constant.SystemConstant;
import com.kakame.codenews.base.web.dao.JdbcBaseDao;
import com.kakame.codenews.base.web.fast.mapping.common.Menu;

@Repository
public class FrontMenuDao extends JdbcBaseDao {
    
    public List<Menu> list(Menu menu) {
        String sql = "";
        sql += "SELECT " + SystemConstant.SINGLE_TABLE_QUERY_ALL_COLUMN;
        sql += "  FROM t_common_menu ";
        sql += " WHERE " + SystemConstant.SINGLE_TABLE_QUERY_WHERE_CONDITION;
        sql += " ORDER BY menu_order ASC";
        List<Menu> list = list(sql, menu);
        return list;
    }
    
}
